Summary Statistics
Select ID, avg(mCpGcount),min(mCpGcount),max(mCpGcount),sum(mCpGcount),count(mCpGcount)
FROM [sr320@washington.edu]. [fish546TJGR_CDS_int_mCpG_2]
Group by ID
Gene information and sequence for genes with GO term containing 'methyl' or 'histone'
SELECT cgslim.CGI_ID,Description,evalue,SPID,GOID,term,GOSlim_bin,sequence
FROM [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim] cgslim
LEFT JOIN [sr320@washington.edu].[qDOD_Cgigas_gene_fasta] cgf
on cgslim.CGI_ID = cgf.CGI_ID
Where term LIKE '%methyl%'
OR
term LIKE '%histone%'